About Course

  • This is a course that teaches you how to perform scenario and sensitivity analysis in Excel, which are useful techniques for financial modeling and analysis.

    • This course covers topics such as:

    • How to create different scenarios and analyze key metrics using data tables.
    • Forecasting the income statement, balance sheet, and cash flow statement.How to use solver, goal seek, and scenario manager to perform simulation analysis.
    • How to create gravity sort tables and tornado charts to present the results.
    • How to make the outputs presentation-ready and professional
    • This course is designed for anyone who wants to learn how to perform scenario and sensitivity analysis in Excel, especially for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. The course requires some basic knowledge of Excel and financial statements.



Eligibilities

--- Finance and Banking ---

Scenario & Sensitivity Analysis - Advance Excel Professional

Total Days
26 Days
+
Total Hours
170 Hours
Training Mode
Price


Related Courses

Understanding & Driving Economics for Capital Markets
Know More
3 - Statement Modelling - Level 4
Know More




Online BootcampPreferred
  • Flexi Pass Enabled: Flexibility to reschedule your cohort within first 90 days of access.
  • Live, online classroom training by top instructors and practitioners.
  • One year access to high-quality self-paced eLearning content curated by industry experts.
Classroom TrainingPreferred
  • Customized Training Solutions: Tailor classroom sessions to your team's needs, with options for instructor-led or blended learning formats.
  • One year access to high-quality self-paced eLearning content curated by industry experts.
  • Interactive Learning Environment: Engage with a simple, interactive setup that encourages active participation and hands-on learning.
Corporate Training
  • Customize the learning model according to your team's needs. Get digital material, instructor-led classes or both.
  • Get flexible pricing options according to your company's needs.
  • Simple and interactive Learning Management System (LMS).
  • Enterprise dashboard for individual learners or teams.
  • Learner support and assistance available 24/7.
  • One year access to high-quality self-paced eLearning content curated by industry experts.


Documents